

/****** Object:  StoredProcedure [dbo].[SP_recMenu_Update]    Script Date: 05/10/2014 08:23:09 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author:		Beni Khaeroni (jhung.ben@gmail.com)
-- Create date: 09 Mei 2014 10:20 AM
-- Description:	
-- =============================================
CREATE PROCEDURE [dbo].[SP_recMenu_Update]
(
	@MenuID						[int],
	@MenuName						[varchar](255),
	@URL						[varchar](255),
	@ParentMenuID						[int],
	@OrderSeq						[int],
	--@CreatedBy						[varchar](50),
	--@CreatedDate						[datetime],
	@UpdatedBy						[varchar](50),
	@UpdatedDate						[datetime]
)
AS UPDATE master.recMenu
SET
		--MenuID			=	@MenuID,
		MenuName			=	@MenuName,
		URL			=	@URL,
		ParentMenuID			=	@ParentMenuID,
		OrderSeq			=	@OrderSeq,
		--CreatedBy			=	@CreatedBy,
		--CreatedDate			=	@CreatedDate,
		UpdatedBy			=	@UpdatedBy,
		UpdatedDate			=	@UpdatedDate
WHERE
(
	 [MenuID]	 = @MenuID
)
GO


